<?php
/**
 * Zend Framework
 *
 * LICENSE
 *
 * This source file is subject to the new BSD license that is bundled
 * with this package in the file LICENSE.txt.
 * It is also available through the world-wide-web at this URL:
 * http://framework.zend.com/license/new-bsd
 * If you did not receive a copy of the license and are unable to
 * obtain it through the world-wide-web, please send an email
 * to license@zend.com so we can send you a copy immediately.
 *
 * @category   Zend
 * @package    Zend_Amf
 * @copyright  Copyright (c) 2005-2009 Zend Technologies USA Inc. (http://www.zend.com)
 * @license    http://framework.zend.com/license/new-bsd     New BSD License
 * @version    $Id: DbInspector.php 16971 2009-07-22 18:05:45Z mikaelkael $
 */

/**
 * This class implements authentication against XML file with roles for Flex Builder.
 *
 * @package    Zend_Amf
 * @subpackage Adobe
 * @copyright  Copyright (c) 2005-2009 Zend Technologies USA Inc. (http://www.zend.com)
 * @license    http://framework.zend.com/license/new-bsd     New BSD License
 */
class Zend_Amf_Adobe_DbInspector
{

	/**
	 * Connect to the database
	 *
	 * @param string $dbType Database adapter type for Zend_Db
	 * @param array|object $dbDescription Adapter-specific connection settings
	 * @return Zend_Db_Adapter_Abstract
	 * @see Zend_Db::factory()
	 */
	protected function _connect($dbType, $dbDescription) 
	{
		if(is_object($dbDescription)) {
			$dbDescription = get_object_vars($dbDescription);
		}
		return Zend_Db::factory($dbType, $dbDescription);
	}
	
	/**
	 * Describe database object. 
	 * 
	 * Usage example:
	 * $inspector->describeTable('Pdo_Mysql', 
	 * 		array(
	 * 			'host'     => '127.0.0.1',
	 *			'username' => 'webuser',
	 *			'password' => 'xxxxxxxx',
	 *			'dbname'   => 'test'
	 * 		),
	 * 		'mytable'
	 * 	);
	 *
	 * @param string $dbType Database adapter type for Zend_Db
	 * @param array|object $dbDescription Adapter-specific connection settings
	 * @param string $tableName Table name
	 * @return array Table description
	 * @see Zend_Db::describeTable()
	 * @see Zend_Db::factory()
	 */
	public function describeTable($dbType, $dbDescription, $tableName) 
	{
		$db = $this->_connect($dbType, $dbDescription);
		return $db->describeTable($tableName);
	}

	/**
	 * Test database connection
	 *
	 * @param string $dbType Database adapter type for Zend_Db
	 * @param array|object $dbDescription Adapter-specific connection settings
	 * @return bool
	 * @see Zend_Db::factory()
	 */
	public function connect($dbType, $dbDescription) 
	{
		$db = $this->_connect($dbType, $dbDescription);
		$db->listTables();
		return true;
	}
	
	/**
	 * Get the list of database tables
	 *
	 * @param string $dbType Database adapter type for Zend_Db
	 * @param array|object $dbDescription Adapter-specific connection settings
	 * @return array List of the tables
	 */
	public function getTables($dbType, $dbDescription) 
	{
		$db = $this->_connect($dbType, $dbDescription);
		return $db->listTables();
	}
}
